Checking the contents of a stock transfer

11.6 Checking the contents of a stock transfer

MyID does not confirm that the devices you have selected as part of a stock transfer are the correct type, or are from the correct location. You can see if an individual device is assigned to a stock transfer from the View Device screen; however, there is no way to view a list of all devices assigned to a stock transfer within MyID.

If you want to confirm which devices are assigned to a stock transfer, you can run the following SQL against the MyID database:

Copy

select StockTransfers.ReadableName As StockTransfer, Devices.SerialNumber, Devices.StockCode, Locations.Name As Location
from Devices 
inner join StockTransfers on Devices.StockTransferID = Stocktransfers.ID 
inner join Locations on Devices.LocationID = Locations.ID 
order by Devices.StockTransferID

This returns a list of each active stock transfer, with the devices that are assigned to them, along with the devices' stock code and location. For example:

StockTransfer	SerialNumber	StockCode	Location
Headquarters to Western regional office, 10 units of Card (2023-02-03)	TN00013PX	Card	Headquarters
Headquarters to Western regional office, 10 units of Card (2023-02-03)	TN00014PX	Card	Headquarters
Headquarters to Western regional office, 10 units of Card (2023-02-03)	TN00015PX	Card	Headquarters

You can see from this report that only three devices have been assigned to the stock transfer, when the transfer calls for 10 (the ReadableName field in the StockTransfers table provides a good summary of what is expected for the transfer). You can now use the Available Device Stock report to locate seven additional devices with the Card stock code that are currently located at Headquarters, then use the Transfer option to assign them to the stock transfer.

If you discover that the transfer contains devices with the wrong stock code, or are in the wrong location, or the transfer contains too many devices, you can use the Cancel Stock Transfer option on the View Transfer screen, and select the Stock Returned / Not Dispatched option to release the devices and start again with a new stock transfer.